IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SrvrInstnc]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[SrvrInstnc]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SrvrInstnc](
     [SrvrInstncId]       [int] IDENTITY(1,1) NOT NULL,
     [SrvrInstncTypeId]   [int]               NOT NULL,
     [SrvrInstncGrpId]    [int]               NOT NULL CONSTRAINT [DF_SrvrInstnc_SrvrInstncGrpId] DEFAULT ((1)),
     [EnabledFlag]        [tinyint]           NOT NULL CONSTRAINT [DF_SrvrInstnc_EnabledFlag] DEFAULT ((1)),
     [SrvrInstncFullName] [varchar](255)      NOT NULL,
     [LastModDt]          [datetime]          NOT NULL CONSTRAINT [DF_SrvrInstnc_LastModDt] DEFAULT (getdate()),
     CONSTRAINT [PK_SrvrInstance] PRIMARY KEY CLUSTERED ( [SrvrInstncId] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
